Elements and Performance Criteria
- Select and prepare resources
- Plan spreadsheet design
- Create spreadsheet
- Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
- Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
- Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
- Use manuals, user documentation and online help to overcome problems with spreadsheet design and production
- Produce simple charts
- Finalise spreadsheets
- Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements
- Ensure data input meets designated timelines and organisational requirements for speed and accuracy
- Name and store spreadsheet in accordance with organisational requirements and exit application without data loss/damage